1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's not just a wireless camera dvr. It has many other functions:Music Play/Video P' at line 3
in:
[select count(p.products_id) as total FROM products p, products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 and ( pd.products_name LIKE '%bathspycamera.com Wireless Spy Camera Pen With Receiver Description:   2.4GHz Wireless Spy Pen Camera With 3.5 Inch DVR Receiver   This product is a 2.4G wireless camera dvr. And it's not just a wireless camera dvr. It has many other functions:Music Play/Video Play/Photo Browsing/E book/Audio Record/Video out/ Synchronous Lyric/Calender%' OR p.products_model LIKE '%bathspycamera.com Wireless Spy Camera Pen With Receiver Description:   2.4GHz Wireless Spy Pen Camera With 3.5 Inch DVR Receiver   This product is a 2.4G wireless camera dvr. And it's not just a wireless camera dvr. It has many other functions:Music Play/Video Play/Photo Browsing/E book/Audio Record/Video out/ Synchronous Lyric/Calender%') ]